Reporting Services Sample Reports

© Copyright Microsoft Corporation, 2003. All rights reserved.

 
The SQL Server documentation team cannot answer technical support questions, but welcomes your suggestions and comments about this readme documentation. You can quickly and directly send e-mail feedback using the link below. All feedback must be in English. To submit written feedback about this document, click here:  Submit feedback.
 

• Overview
  
  
• Topics
  
  
• Location
  
  
• Uploading Sample Reports
  
  
• Viewing Sample Reports
  
  
• Editing Sample Reports

Overview

The sample reports are a collection of reports for Reporting Services. You can upload these reports to a report server for demonstration purposes, or open them in Report Designer to learn how they were made.

Reports

This sample includes the following reports.

• Company Sales – Adventure Works sales by quarter and product category. This report illustrates the use of a matrix data region that provides drilldown from summary data into detail data by showing and hiding rows. This report also illustrates the use of background images.
  
  
• Employee Sales Summary – Adventure Works sales for an individual employee. This report includes Sales Comparison and Current Month Sales Comparison charts in addition to a Current Month Order Summary table with drillthrough to individual orders. This report illustrates the use of multiple datasets, charts, tables, drillthrough, and dynamic parameters.
  
  
• Product Catalog – Adventure Works full product catalog with pictures. This report illustrates the use of embedded images, database images, page breaks, page footers, tables, conditional formatting, and a document map.
  
  
• Product Line Sales – Adventure Works top five sales people and stores. This report illustrates a dataset with queries containing the TOP clause. It also illustrates the use of tables, charts, parameters, calculated fields, and drillthrough links.
  
  
• Sales Order Detail – Detail of an individual Adventure Works order. This report can be accessed as a drillthrough report from the Employee Sales Summary and Territory Sales drilldown report. This report illustrates the use of lists, tables, parameters, and expressions.
  
  
• Territory Sales – Adventure Works sales by territory. This report drills down through salesperson and order number with drillthrough to individual orders. This report illustrates the use of a table data region that provides drilldown from summary data into detail data by showing and hiding rows. This report also illustrates the use of drillthrough links and conditional formatting.
  
  
• Foodmart Sales – Foodmart sales by quarter and product department. This report illustrates the use of an Analysis Services data source. It also illustrates matrix, parameters, filters, calculated fields, and drilldown from summary data into detail data by showing and hiding rows.

System Requirements

Your system must meet the following requirements to use the sample reports.

Server

• Microsoft® SQL Server™ 2000 Reporting Services
  
  
• SQL Server 2000 with the AdventureWorks2000 OLTP database installed (for Adventure Works reports)
  
  
• Analysis Services 2000 with Foodmart database installed (for Foodmart report)

Client

• Microsoft Internet Explorer 5.0 or later
  
  
• Microsoft Visual Studio® .NET with Report Designer installed (optional)

Location

This sample reports are located in the Reports subdirectory of the Reporting Services samples directory.

For Example:

C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\Samples\Reports

Documentation

Each sample report is documented separately in Books Online. For more information, see the Reporting Services Sample Reports topic in Reporting Services Books Online.

NOTE: Documentation for the Product Line Sales report is not included in Books Online.

Uploading Sample Reports

To make the sample reports available for viewing in a Web browser, you must upload the reports to the report server. You can use Report Designer, the Web service or Report Manager to publish the sample report definition files. If you use Report Manager, you must first create a shared data source for the reports.

NOTE: To create a data source and upload files to a folder on the report server, you must have permissions to manage reports for the folder. If My Reports is enabled, you automatically have these permissions for your My Reports folder. For more information, see the Managing My Reports topic in Reporting Services Books Online.

To upload sample reports using Visual Studio .NET

1. Open the SampleReports.sln solution file in Visual Studio .NET. By default, the solution file is installed to C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\Samples\Reports.
   
   
2. On the Visual Studio standard toolbar, select the Production solution configuration. (The default configuration is Debug.)
   
   
3. On the Debug menu, click Start to deploy the sample reports.

To upload sample reports using Report Manager

1. To run the application, type its URL in the address bar of a Web browser. By default, the URL is http://<webservername>/reports.
   
   
2. Navigate to the folder in which to upload the reports. For more information, see the Navigating Folders in the Report Manager topic in Reporting Services Books Online.
   
   
3. Click New Data Source, and then do the following:
   • In Name, type AdventureWorks. The sample reports reference the data source by this name.
     
     
   • In Description, type a description or leave the field blank.
     
     
   • Select Enable this data source.
     
     
   • From Connection Type, select Microsoft SQL Server.
     
     
   • In Connection String, provide the OLE DB connection string to the database that contains the AdventureWorks2000 database. An example of the connection string for a local AdventureWorks2000 database is as follows.

     data source="(local)";persist security info=False;initial catalog=AdventureWorks2000
     

   • From Connect Using, select Windows NT Integrated Security.
4. Click OK to save the data source and return to the folder view.
   
   
5. Click Upload File, and then click Browse to navigate to the folder that contains the sample reports.
   
   
6. Click the file to upload it, and then click Open.
   
   
7. Click OK to open the file.
   
   
8. Repeat steps 5 through 7 for the remaining sample reports.

You can also upload reports using the Rs.exe script utility and a sample script. The script creates a folder, adds a data source, and uploads each sample report. For information about using a script to upload reports, see the Script for Publishing Sample Reports topic in Reporting Services Books Online.

Viewing Sample Reports

After the reports are uploaded, you can view them in Report Manager.

NOTE: Before you run the reports, ensure that the AdventureWorks2000 OLTP database is available to the reports. For information the AdventureWorks2000 database, see the AdventureWorks Sample Database topic in Reporting Services Books Online.

To view sample reports using Report Manager

1. To run the application, type its URL in the address bar of a Web browser. By default, the URL is http://<webservername>/reports.
   
   
2. Navigate to the folder that contains the reports. For more information, see the Navigating Folders and Reports topic in Reporting Services Books Online.
   
   
3. Click the name of the report that you want to view to open it.

Editing Sample Reports

You can edit the Sample Reports in Report Designer.

To edit sample reports using Report Designer

• Open the SampleReports.sln solution file in Visual Studio .NET. By default, the solution file is installed to C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\Samples\Reports. For more information, see the Building Reports topic in Reporting Services Books Online. You can also publish reports to a report server through Report Designer. For more information, see the Debugging and Publishing Reports topic in Reporting Services Books Online.

NOTE: The SampleReports.sln solution file contains two solution configurations: Debug and Production. This differs slightly from configurations in newly created report projects. In the sample reports solution, you can use the Debug configuration to preview reports locally, and the Production configuration to publish reports to the report server. For information about the default configurations for new report projects, see the Debugging and Publishing Reports topic in Reporting Services Books Online.